Dashboard - Van Sales module

  • Last Created On Nov 07, 2025
  • 16
0 0

Overview 

Revenue: Calculates the total order value based on the selected filters. Only includes orders with the following statuses: Pending Payment, Paid, and Finished.

Sales Orders: Counts the total number of sales orders based on the selected filters. Only includes orders with the following statuses: Pending Payment, Paid, and Finished.

Customers with Order: Counts the number of customers who made purchases based on the selected filters. Each customer is counted only once, even if they have multiple orders.

Route Schedule: Counts the number of route schedules based on the selected filters, including only those with statuses Started and Finished.



Revenue Trends

This report shows the revenue trend over the past 6 months, allowing comparison between the Target Value and Actual Revenue for each month.

  • Target Value: Represents the total sales target (Total Order Value) aggregated from all KPIs for that month, excluding those in Draft status → Indicates the expected revenue that the sales team aims to achieve.
  • Actual Revenue: Represents the total value of actual sales orders within the month, including only orders with statuses Finished, Paid, or Pending Payment → Reflects the actual performance achieved compared to the set target.

Best Setting Products

This report displays the Top 10 products with the highest quantity sold, including both regular and gift products, based on the selected filter conditions (time period and driver). The results are not affected by the Route filter condition.

Real-time Vehicle Location

Displays the current location of each vehicle based on the latest position of the driver during the execution of a route schedule.

The system automatically checks for location changes compared to the previous position (with a minimum difference of 10 meters).

If a change is detected, the new coordinates (latitude and longitude) are saved to the server, and the vehicle’s position on the map is updated accordingly.

Drivers Performance

The report is calculated by month

If a half-month period is selected, the monthly KPI/Target is still used to calculate performance.

  • Performance (%) = (Actual Revenue / Target of Total Order Value) × 100. Actual revenue is based on orders related to the route schedule (the driver is taken from the schedule, not from the order).
  • Distance is taken from the Actual Distance field in the route schedules.


Sales


Product Distribution

The pie chart illustrates the distribution percentage of sold products based on order.

Product Distribution (%) = (Quantity Sold of Product / Total Quantity Sold of All Products) × 100

The quantities are derived from orders with the statuses Paid, Pending Payment, and Finished, and include gift products as well.




High Demand Sales Points 

This chart displays the top 10 route points with the highest total quantity of products sold, including gift products. The product quantities are calculated from orders with the statuses Finished, Pending Payment, and Paid.


Sales by Route 

When a user clicks on a route point in the High Demand Sales Points chart, the product details and quantities sold for that specific route point will be displayed — including gift products.


Route Schedule 

Displays all route schedules with the status Finished.


Performance


Employee Performance 

Performance = (Actual Duration / Planned Duration ) x 100

Total Sales = Calculates the total order value of each employee. Only includes orders with the following statuses: Pending PaymentPaid, and Finished.


Time Distribution 

The chart shows the percentage distribution of break time by type for all employees.
The percentage of each break type is calculated as: Break Time Percentage = Break time of each type / Total break time. 
Break time data is taken from Schedules with statuses "Finish".


Performance Trends

This chart illustrates the work performance trend and average distance over time.
Performance % = (Actual Travel Time) / (Planned Travel Time)
Average Distance = Total Actual Distance / Number of Finished Routes

Detail of Visits

Statistics of locations with orders generated from schedules with the status "finished" and corresponding orders with the following statuses: finished, paid, pending payment, Mỗi route point includes information on Actual Visit Time, Actual Departure, and Service Time, Status.

Views: 16

Recent Articles

  • Dashboard - Van Sales module
    16
  • Van Sales Report
    11
  • Route Schedule Overview
    24
  • Permission Settings
    19
  • Movement Inventory
    24

Popular Articles

  • Warehouse
    1835
  • Item Settings
    1537
  • General Accounting Settings
    1234
  • Mapping Setup
    1163
  • Inventory Receiving Voucher
    1115